<?php
$prefix = XINGLE_DB_PREFIX;

$lastModified = $this -> _db -> arrayQuery(
  "SELECT
    c.tstamp, c.title, u.URL
  FROM
    {$prefix}doc AS d,
    {$prefix}content AS c,
    {$prefix}url AS u
  WHERE
    d.id = c.docId AND
    d.state != 'removed' AND
    c.actual = 1 AND
    c.lang = d.defaultLang AND
    u.docId = d.id AND
    LEFT(u.URL, 8) != '/@xingle'
  ORDER BY c.tstamp DESC
  LIMIT 10",
  "URL"
);

if(count($lastModified) > 0){?>
<ul>
<?php
  foreach($lastModified as $url => $data){?>
<li><a href="<?php echo $url ?>"><?php echo $data['title'] ?></a> [<small><?php echo date("d-m-Y H:i:s", $data['tstamp']) ?></small>]</li>
<?php  }
?>
</ul>
<?php
}
?>